Stored Procedures [dbo].[BAEFixEventStatus]
SQLServer > iMIS1521GA > Stored Procedures > dbo.BAEFixEventStatus
Properties
PropertyValue
ANSI Nulls OnYes
Quoted Identifier OnYes
Parameters
NameData TypeMax Length (Bytes)
@orderIDint4
SQL Script
create procedure [dbo].[BAEFixEventStatus] @orderID int as
UPDATE Orders
    SET STATUS = ''
    WHERE ORDER_NUMBER = @orderID

GO
Uses
Created 05 April 2012 11:11
Copyright  2012 - All Rights Reserved